Tabela LEventPersonnel

Definicja tabeli LEventPersonnel

Name

LEventPersonnel

Code

LEventPersonnel

Comment

Lekarz kwalifikujacy


Lista kolumn tabeli LEventPersonnel

Name

Code

LEventPersonnelID

LEventPersonnelID

PersonnelFunctionID

PersonnelFunctionID

EventID

EventID

PersonID

PersonID

StartDT

StartDT

StopDT

StopDT

Active

Active

InsertDate

InsertDate

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson


Kolumna LEventPersonnelID tabeli LEventPersonnel

Definicja kolumny LEventPersonnelID tabeli LEventPersonnel

Name

LEventPersonnelID

Code

LEventPersonnelID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonnelFunctionID tabeli LEventPersonnel

Definicja kolumny PersonnelFunctionID tabeli LEventPersonnel

Name

PersonnelFunctionID

Code

PersonnelFunctionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EventID tabeli LEventPersonnel

Definicja kolumny EventID tabeli LEventPersonnel

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli LEventPersonnel

Definicja kolumny PersonID tabeli LEventPersonnel

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LEventPersonnel

Definicja kolumny StartDT tabeli LEventPersonnel

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LEventPersonnel

Definicja kolumny StopDT tabeli LEventPersonnel

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Active tabeli LEventPersonnel

Definicja kolumny Active tabeli LEventPersonnel

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna InsertDate tabeli LEventPersonnel

Definicja kolumny InsertDate tabeli LEventPersonnel

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

Yes

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna InsertingPerson tabeli LEventPersonnel

Definicja kolumny InsertingPerson tabeli LEventPersonnel

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna LastModifiedDT tabeli LEventPersonnel

Definicja kolumny LastModifiedDT tabeli LEventPersonnel

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

Yes

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli LEventPersonnel

Definicja kolumny LastModifiedPerson tabeli LEventPersonnel

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Lista kluczy tabeli LEventPersonnel

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LEventPersonnel

Definicja klucza Identifier_1 tabeli LEventPersonnel

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment